Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	8920
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	164.0 B

Variable types

Numeric	21

Alerts

`df_index` is highly correlated with `cust_id`	High correlation
`cust_id` is highly correlated with `df_index`	High correlation
`balance` is highly correlated with `balance_frequency` and 5 other fields	High correlation
`balance_frequency` is highly correlated with `balance` and 1 other fields	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 6 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance` is highly correlated with `balance` and 3 other fields	High correlation
`purchases_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance_frequency` is highly correlated with `balance` and 3 other fields	High correlation
`cash_advance_trx` is highly correlated with `balance` and 3 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 5 other fields	High correlation
`minimum_payments` is highly correlated with `balance` and 1 other fields	High correlation
`purchases_avg` is highly correlated with `purchases` and 2 other fields	High correlation
`cash_advance_avg` is highly correlated with `balance` and 3 other fields	High correlation
`df_index` is highly correlated with `cust_id`	High correlation
`cust_id` is highly correlated with `df_index`	High correlation
`balance` is highly correlated with `credit_limit`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 3 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_frequency` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `oneoff_purchases_frequency` and 2 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `oneoff_purchases` and 2 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `installments_purchases` and 2 other fields	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance` and 1 other fields	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 5 other fields	High correlation
`credit_limit` is highly correlated with `balance`	High correlation
`payments` is highly correlated with `purchases` and 1 other fields	High correlation
`df_index` is highly correlated with `cust_id`	High correlation
`cust_id` is highly correlated with `df_index`	High correlation
`balance` is highly correlated with `minimum_payments`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 5 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_frequency` and 2 other fields	High correlation
`purchases_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases` and 1 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `installments_purchases` and 2 other fields	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance` and 2 other fields	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 2 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 3 other fields	High correlation
`minimum_payments` is highly correlated with `balance`	High correlation
`purchases_avg` is highly correlated with `purchases` and 1 other fields	High correlation
`cash_advance_avg` is highly correlated with `cash_advance` and 2 other fields	High correlation
`df_index` is highly correlated with `cust_id`	High correlation
`cust_id` is highly correlated with `df_index`	High correlation
`balance` is highly correlated with `credit_limit`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 4 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 1 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_trx` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `oneoff_purchases_frequency` and 1 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases_frequency`	High correlation
`purchases_installments_frequency` is highly correlated with `purchases_frequency`	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance_trx`	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 3 other fields	High correlation
`credit_limit` is highly correlated with `balance` and 2 other fields	High correlation
`payments` is highly correlated with `purchases` and 5 other fields	High correlation
`purchases_avg` is highly correlated with `payments`	High correlation
`df_index` is uniformly distributed	Uniform
`cust_id` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`cust_id` has unique values	Unique
`purchases` has 2038 (22.8%) zeros	Zeros
`oneoff_purchases` has 4283 (48.0%) zeros	Zeros
`installments_purchases` has 3904 (43.8%) zeros	Zeros
`cash_advance` has 4612 (51.7%) zeros	Zeros
`purchases_frequency` has 2038 (22.8%) zeros	Zeros
`oneoff_purchases_frequency` has 4283 (48.0%) zeros	Zeros
`purchases_installments_frequency` has 3904 (43.8%) zeros	Zeros
`cash_advance_frequency` has 4612 (51.7%) zeros	Zeros
`cash_advance_trx` has 4612 (51.7%) zeros	Zeros
`purchases_trx` has 2036 (22.8%) zeros	Zeros
`payments` has 240 (2.7%) zeros	Zeros
`minimum_payments` has 313 (3.5%) zeros	Zeros
`prc_full_payment` has 5878 (65.9%) zeros	Zeros
`purchases_avg` has 2038 (22.8%) zeros	Zeros
`cash_advance_avg` has 4612 (51.7%) zeros	Zeros

Reproduction

Analysis started	2021-11-30 12:49:31.838214
Analysis finished	2021-11-30 12:51:16.243143
Duration	1 minute and 44.4 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	8920
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4474.136883

Minimum	0
Maximum	8949
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	445.95
Q1	2236.75
median	4472.5
Q3	6712.25
95-th percentile	8502.05
Maximum	8949
Range	8949
Interquartile range (IQR)	4475.5

Descriptive statistics

Standard deviation	2584.092911
Coefficient of variation (CV)	0.5775623272
Kurtosis	-1.200105095
Mean	4474.136883
Median Absolute Deviation (MAD)	2237.5
Skewness	0.0003342727901
Sum	39909301
Variance	6677536.171
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
605	1	< 0.1%
2644	1	< 0.1%
597	1	< 0.1%
6742	1	< 0.1%
4695	1	< 0.1%
8793	1	< 0.1%
2652	1	< 0.1%
6750	1	< 0.1%
2668	1	< 0.1%
Other values (8910)	8910	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
8949	1	< 0.1%
8948	1	< 0.1%
8947	1	< 0.1%
8946	1	< 0.1%
8945	1	< 0.1%
8944	1	< 0.1%
8943	1	< 0.1%
8942	1	< 0.1%
8941	1	< 0.1%
8940	1	< 0.1%

cust_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	8920
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14599.66637

Minimum	10001
Maximum	19190
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.0 KiB

Quantile statistics

Minimum	10001
5-th percentile	10461.95
Q1	12306.75
median	14596.5
Q3	16900.25
95-th percentile	18733.05
Maximum	19190
Range	9189
Interquartile range (IQR)	4593.5

Descriptive statistics

Standard deviation	2651.620337
Coefficient of variation (CV)	0.1816219816
Kurtosis	-1.199360604
Mean	14599.66637
Median Absolute Deviation (MAD)	2296.5
Skewness	-0.0004945342566
Sum	130229024
Variance	7031090.412
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16384	1	< 0.1%
14922	1	< 0.1%
10816	1	< 0.1%
14914	1	< 0.1%
12867	1	< 0.1%
19012	1	< 0.1%
16965	1	< 0.1%
10824	1	< 0.1%
12875	1	< 0.1%
10840	1	< 0.1%
Other values (8910)	8910	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10001	1	< 0.1%
10002	1	< 0.1%
10003	1	< 0.1%
10004	1	< 0.1%
10005	1	< 0.1%
10006	1	< 0.1%
10007	1	< 0.1%
10008	1	< 0.1%
10009	1	< 0.1%
10010	1	< 0.1%

Value	Count	Frequency (%)
19190	1	< 0.1%
19189	1	< 0.1%
19188	1	< 0.1%
19187	1	< 0.1%
19186	1	< 0.1%
19185	1	< 0.1%
19184	1	< 0.1%
19183	1	< 0.1%
19182	1	< 0.1%
19181	1	< 0.1%

balance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8841
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1562.512922

Minimum	0
Maximum	19043.13856
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	8.82004985
Q1	128.3728552
median	871.534477
Q3	2049.707459
95-th percentile	5906.232841
Maximum	19043.13856
Range	19043.13856
Interquartile range (IQR)	1921.334604

Descriptive statistics

Standard deviation	2079.408643
Coefficient of variation (CV)	1.330810525
Kurtosis	7.714122828
Mean	1562.512922
Median Absolute Deviation (MAD)	798.3892365
Skewness	2.397770669
Sum	13937615.27
Variance	4323940.304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80	0.9%
74.825456	1	< 0.1%
155.676255	1	< 0.1%
34.750769	1	< 0.1%
2643.343414	1	< 0.1%
6366.085376	1	< 0.1%
1112.915657	1	< 0.1%
2545.614986	1	< 0.1%
449.026889	1	< 0.1%
1722.910058	1	< 0.1%
Other values (8831)	8831	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.006651	1	< 0.1%
0.009684	1	< 0.1%
0.01968	1	< 0.1%
0.021102	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14581.45914	1	< 0.1%

balance_frequency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	43
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8772435415

Minimum	0
Maximum	1
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.272727
Q1	0.888889
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.111111

Descriptive statistics

Standard deviation	0.2369232478
Coefficient of variation (CV)	0.270076936
Kurtosis	3.096858681
Mean	0.8772435415
Median Absolute Deviation (MAD)	0
Skewness	-2.023939108
Sum	7825.01239
Variance	0.05613262536
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
1	6189	69.4%
0.909091	408	4.6%
0.818182	278	3.1%
0.727273	223	2.5%
0.545455	219	2.5%
0.636364	209	2.3%
0.363636	170	1.9%
0.454545	169	1.9%
0.272727	149	1.7%
0.181818	146	1.6%
Other values (33)	760	8.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.090909	67	0.8%
0.1	8	0.1%
0.111111	5	0.1%
0.125	9	0.1%
0.142857	7	0.1%
0.166667	7	0.1%
0.181818	146	1.6%
0.2	9	0.1%
0.222222	5	0.1%

Value	Count	Frequency (%)
1	6189	69.4%
0.909091	408	4.6%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.6%
0.857143	51	0.6%
0.833333	59	0.7%
0.818182	278	3.1%
0.8	20	0.2%
0.777778	22	0.2%

purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	6180
Distinct (%)	69.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1004.733073

Minimum	0
Maximum	49039.57
Zeros	2038
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39.57
median	362.305
Q3	1112.425
95-th percentile	4000.009
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1072.855

Descriptive statistics

Standard deviation	2139.075941
Coefficient of variation (CV)	2.128999233
Kurtosis	111.2247759
Mean	1004.733073
Median Absolute Deviation (MAD)	362.305
Skewness	8.140453832
Sum	8962219.01
Variance	4575645.883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2038	22.8%
45.65	27	0.3%
60	16	0.2%
150	16	0.2%
300	13	0.1%
100	13	0.1%
200	13	0.1%
450	12	0.1%
70	10	0.1%
120	10	0.1%
Other values (6170)	6752	75.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2038	22.8%
0.01	4	< 0.1%
0.05	1	< 0.1%
0.7	1	< 0.1%
1	2	< 0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
4.99	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

oneoff_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4004
Distinct (%)	44.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	593.7731491

Minimum	0
Maximum	40761.25
Zeros	4283
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	39
Q3	581.015
95-th percentile	2675.0315
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	581.015

Descriptive statistics

Standard deviation	1662.139174
Coefficient of variation (CV)	2.799283154
Kurtosis	163.8101308
Mean	593.7731491
Median Absolute Deviation (MAD)	39
Skewness	10.0351636
Sum	5296456.49
Variance	2762706.633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4283	48.0%
45.65	45	0.5%
50	17	0.2%
200	15	0.2%
60	13	0.1%
100	13	0.1%
1000	12	0.1%
70	12	0.1%
150	12	0.1%
250	11	0.1%
Other values (3994)	4487	50.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4283	48.0%
0.01	7	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.7	1	< 0.1%
1	4	< 0.1%
1.4	2	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

installments_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4437
Distinct (%)	49.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	410.9599238

Minimum	0
Maximum	22500
Zeros	3904
Zeros (%)	43.8%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89.18
Q3	467.34
95-th percentile	1753.284
Maximum	22500
Range	22500
Interquartile range (IQR)	467.34

Descriptive statistics

Standard deviation	903.5509971
Coefficient of variation (CV)	2.198635305
Kurtosis	97.06942256
Mean	410.9599238
Median Absolute Deviation (MAD)	89.18
Skewness	7.313374299
Sum	3665762.52
Variance	816404.4044
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3904	43.8%
200	14	0.2%
100	14	0.2%
300	14	0.2%
150	12	0.1%
125	11	0.1%
75	9	0.1%
450	8	0.1%
350	8	0.1%
500	8	0.1%
Other values (4427)	4918	55.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3904	43.8%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.28	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

cash_advance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4309
Distinct (%)	48.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	977.9975392

Minimum	0
Maximum	47137.21176
Zeros	4612
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1113.273292
95-th percentile	4639.920152
Maximum	47137.21176
Range	47137.21176
Interquartile range (IQR)	1113.273292

Descriptive statistics

Standard deviation	2097.519305
Coefficient of variation (CV)	2.144708162
Kurtosis	53.0434044
Mean	977.9975392
Median Absolute Deviation (MAD)	0
Skewness	5.176949006
Sum	8723738.05
Variance	4399587.234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4612	51.7%
920.309805	1	< 0.1%
724.694411	1	< 0.1%
1420.758241	1	< 0.1%
2081.583331	1	< 0.1%
2970.97936	1	< 0.1%
4353.620039	1	< 0.1%
8641.998958	1	< 0.1%
4962.936839	1	< 0.1%
3061.014837	1	< 0.1%
Other values (4299)	4299	48.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4612	51.7%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.204577	1	< 0.1%
18.240626	1	< 0.1%
18.280043	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%
23130.82106	1	< 0.1%
22665.7785	1	< 0.1%
21943.84942	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%

purchases_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4905560407

Minimum	0
Maximum	1
Zeros	2038
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.4014905514
Coefficient of variation (CV)	0.8184397256
Kurtosis	-1.63936366
Mean	0.4905560407
Median Absolute Deviation (MAD)	0.416667
Skewness	0.05888288058
Sum	4375.759883
Variance	0.1611946628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2173	24.4%
0	2038	22.8%
0.083333	675	7.6%
0.5	394	4.4%
0.916667	394	4.4%
0.166667	391	4.4%
0.833333	372	4.2%
0.333333	365	4.1%
0.25	342	3.8%
0.583333	315	3.5%
Other values (37)	1461	16.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2038	22.8%
0.083333	675	7.6%
0.090909	43	0.5%
0.1	26	0.3%
0.111111	18	0.2%
0.125	31	0.3%
0.142857	26	0.3%
0.166667	391	4.4%
0.181818	16	0.2%
0.2	19	0.2%

Value	Count	Frequency (%)
1	2173	24.4%
0.916667	394	4.4%
0.909091	28	0.3%
0.9	24	0.3%
0.888889	18	0.2%
0.875	26	0.3%
0.857143	25	0.3%
0.833333	372	4.2%
0.818182	21	0.2%
0.8	9	0.1%

oneoff_purchases_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.202867074

Minimum	0
Maximum	1
Zeros	4283
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.3
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.2986539051
Coefficient of variation (CV)	1.472165489
Kurtosis	1.149099359
Mean	0.202867074
Median Absolute Deviation (MAD)	0.083333
Skewness	1.532304114
Sum	1809.5743
Variance	0.08919415504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4283	48.0%
0.083333	1101	12.3%
0.166667	592	6.6%
1	481	5.4%
0.25	415	4.7%
0.333333	354	4.0%
0.416667	244	2.7%
0.5	234	2.6%
0.583333	197	2.2%
0.666667	167	1.9%
Other values (37)	852	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4283	48.0%
0.083333	1101	12.3%
0.090909	56	0.6%
0.1	38	0.4%
0.111111	26	0.3%
0.125	40	0.4%
0.142857	37	0.4%
0.166667	592	6.6%
0.181818	34	0.4%
0.2	27	0.3%

Value	Count	Frequency (%)
1	481	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	120	1.3%
0.818182	10	0.1%
0.8	4	< 0.1%

purchases_installments_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3644958629

Minimum	0
Maximum	1
Zeros	3904
Zeros (%)	43.8%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.3974575441
Coefficient of variation (CV)	1.090430879
Kurtosis	-1.3991404
Mean	0.3644958629
Median Absolute Deviation (MAD)	0.166667
Skewness	0.5086379574
Sum	3251.303097
Variance	0.1579724994
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	3904	43.8%
1	1326	14.9%
0.416667	388	4.3%
0.916667	344	3.9%
0.833333	310	3.5%
0.5	309	3.5%
0.166667	303	3.4%
0.666667	291	3.3%
0.75	290	3.3%
0.083333	271	3.0%
Other values (37)	1184	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3904	43.8%
0.083333	271	3.0%
0.090909	12	0.1%
0.1	6	0.1%
0.111111	9	0.1%
0.125	5	0.1%
0.142857	6	0.1%
0.166667	303	3.4%
0.181818	14	0.2%
0.2	9	0.1%

Value	Count	Frequency (%)
1	1326	14.9%
0.916667	344	3.9%
0.909091	25	0.3%
0.9	19	0.2%
0.888889	28	0.3%
0.875	28	0.3%
0.857143	30	0.3%
0.833333	310	3.5%
0.818182	21	0.2%
0.8	18	0.2%

cash_advance_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1343701601

Minimum	0
Maximum	1
Zeros	4612
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.222222
95-th percentile	0.583333
Maximum	1
Range	1
Interquartile range (IQR)	0.222222

Descriptive statistics

Standard deviation	0.1977454896
Coefficient of variation (CV)	1.471647347
Kurtosis	2.886218301
Mean	0.1343701601
Median Absolute Deviation (MAD)	0
Skewness	1.769252535
Sum	1198.581828
Variance	0.03910327864
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4612	51.7%
0.083333	1018	11.4%
0.166667	759	8.5%
0.25	577	6.5%
0.333333	438	4.9%
0.416667	273	3.1%
0.5	215	2.4%
0.583333	141	1.6%
0.666667	125	1.4%
0.090909	70	0.8%
Other values (37)	692	7.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4612	51.7%
0.083333	1018	11.4%
0.090909	70	0.8%
0.1	39	0.4%
0.111111	29	0.3%
0.125	47	0.5%
0.142857	49	0.5%
0.166667	759	8.5%
0.181818	42	0.5%
0.2	21	0.2%

Value	Count	Frequency (%)
1	25	0.3%
0.916667	27	0.3%
0.909091	3	< 0.1%
0.9	2	< 0.1%
0.888889	2	< 0.1%
0.875	5	0.1%
0.857143	5	0.1%
0.833333	48	0.5%
0.818182	2	< 0.1%
0.8	6	0.1%

cash_advance_trx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	65
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.239461883

Minimum	0
Maximum	123
Zeros	4612
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.814954483
Coefficient of variation (CV)	2.103730412
Kurtosis	62.21440988
Mean	3.239461883
Median Absolute Deviation (MAD)	0
Skewness	5.752721811
Sum	28896
Variance	46.4436046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4612	51.7%
1	886	9.9%
2	619	6.9%
3	436	4.9%
4	382	4.3%
5	307	3.4%
6	246	2.8%
7	205	2.3%
8	171	1.9%
10	149	1.7%
Other values (55)	907	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4612	51.7%
1	886	9.9%
2	619	6.9%
3	436	4.9%
4	382	4.3%
5	307	3.4%
6	246	2.8%
7	205	2.3%
8	171	1.9%
9	111	1.2%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
62	3	< 0.1%
61	1	< 0.1%

purchases_trx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	173
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.72466368

Minimum	0
Maximum	358
Zeros	2036
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	17
95-th percentile	57
Maximum	358
Range	358
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	24.87834234
Coefficient of variation (CV)	1.689569479
Kurtosis	34.77673531
Mean	14.72466368
Median Absolute Deviation (MAD)	7
Skewness	4.630671453
Sum	131344
Variance	618.9319177
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2036	22.8%
1	665	7.5%
12	570	6.4%
2	376	4.2%
6	350	3.9%
3	313	3.5%
4	285	3.2%
7	274	3.1%
8	267	3.0%
5	263	2.9%
Other values (163)	3521	39.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2036	22.8%
1	665	7.5%
2	376	4.2%
3	313	3.5%
4	285	3.2%
5	263	2.9%
6	350	3.9%
7	274	3.1%
8	267	3.0%
9	248	2.8%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

credit_limit
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	205
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4492.51997

Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3638.641132
Coefficient of variation (CV)	0.8099332126
Kurtosis	2.845871581
Mean	4492.51997
Median Absolute Deviation (MAD)	1800
Skewness	1.523857227
Sum	40073278.13
Variance	13239709.29
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	781	8.8%
1500	721	8.1%
1200	619	6.9%
2500	611	6.8%
1000	610	6.8%
4000	504	5.7%
6000	461	5.2%
5000	387	4.3%
2000	370	4.1%
7500	277	3.1%
Other values (195)	3579	40.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	2	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%
450	6	0.1%
500	121	1.4%
600	21	0.2%
650	1	< 0.1%
700	20	0.2%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

payments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	8681
Distinct (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1731.830582

Minimum	0
Maximum	50721.48336
Zeros	240
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	89.86248575
Q1	383.280622
median	857.8868165
Q3	1904.981381
95-th percentile	6083.430983
Maximum	50721.48336
Range	50721.48336
Interquartile range (IQR)	1521.700759

Descriptive statistics

Standard deviation	2884.060385
Coefficient of variation (CV)	1.665324782
Kurtosis	54.96966457
Mean	1731.830582
Median Absolute Deviation (MAD)	582.176172
Skewness	5.90182428
Sum	15447928.79
Variance	8317804.306
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	240	2.7%
282.414709	1	< 0.1%
817.050377	1	< 0.1%
284.093261	1	< 0.1%
1333.446631	1	< 0.1%
1265.31093	1	< 0.1%
453.19428	1	< 0.1%
3530.131795	1	< 0.1%
414.218007	1	< 0.1%
2857.881585	1	< 0.1%
Other values (8671)	8671	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	240	2.7%
0.049513	1	< 0.1%
0.056466	1	< 0.1%
2.389583	1	< 0.1%
3.500505	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
5.070726	1	< 0.1%
9.040017	1	< 0.1%
9.533313	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
34107.07499	1	< 0.1%
33994.72785	1	< 0.1%
33486.31044	1	< 0.1%

minimum_payments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	8607
Distinct (%)	96.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	834.2181165

Minimum	0
Maximum	76406.20752
Zeros	313
Zeros (%)	3.5%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	29.69426285
Q1	163.0290433
median	289.514532
Q3	787.173152
95-th percentile	2722.274019
Maximum	76406.20752
Range	76406.20752
Interquartile range (IQR)	624.1441087

Descriptive statistics

Standard deviation	2339.137016
Coefficient of variation (CV)	2.803987314
Kurtosis	291.752683
Mean	834.2181165
Median Absolute Deviation (MAD)	188.4782655
Skewness	13.79779351
Sum	7441225.599
Variance	5471561.98
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	313	3.5%
299.351881	2	< 0.1%
1340.320342	1	< 0.1%
160.863666	1	< 0.1%
210.156238	1	< 0.1%
200.106261	1	< 0.1%
25697.63772	1	< 0.1%
427.14706	1	< 0.1%
227.726516	1	< 0.1%
438.190574	1	< 0.1%
Other values (8597)	8597	96.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	313	3.5%
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%
0.261984	1	< 0.1%
0.311953	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%
42629.55117	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%

prc_full_payment
Real number (ℝ_≥0)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.153857934

Minimum	0
Maximum	1
Zeros	5878
Zeros (%)	65.9%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.142857
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.142857

Descriptive statistics

Standard deviation	0.2925724792
Coefficient of variation (CV)	1.901575509
Kurtosis	2.428781777
Mean	0.153857934
Median Absolute Deviation (MAD)	0
Skewness	1.941892824
Sum	1372.412771
Variance	0.08559865557
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	5878	65.9%
1	487	5.5%
0.083333	426	4.8%
0.166667	166	1.9%
0.25	156	1.7%
0.5	155	1.7%
0.090909	153	1.7%
0.333333	133	1.5%
0.1	94	1.1%
0.2	83	0.9%
Other values (37)	1189	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5878	65.9%
0.083333	426	4.8%
0.090909	153	1.7%
0.1	94	1.1%
0.111111	61	0.7%
0.125	52	0.6%
0.142857	54	0.6%
0.166667	166	1.9%
0.181818	75	0.8%
0.2	83	0.9%

Value	Count	Frequency (%)
1	487	5.5%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%
0.875	18	0.2%
0.857143	12	0.1%
0.833333	62	0.7%
0.818182	17	0.2%
0.8	33	0.4%

tenure
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.52073991

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.332919677
Coefficient of variation (CV)	0.115697402
Kurtosis	7.777202151
Mean	11.52073991
Median Absolute Deviation (MAD)	0
Skewness	-2.955438266
Sum	102765
Variance	1.776674865
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	7565	84.8%
11	364	4.1%
10	234	2.6%
6	200	2.2%
8	194	2.2%
7	189	2.1%
9	174	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	200	2.2%
7	189	2.1%
8	194	2.2%
9	174	2.0%
10	234	2.6%
11	364	4.1%
12	7565	84.8%

Value	Count	Frequency (%)
12	7565	84.8%
11	364	4.1%
10	234	2.6%
9	174	2.0%
8	194	2.2%
7	189	2.1%
6	200	2.2%

purchases_avg
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	6171
Distinct (%)	69.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.92179897

Minimum	0
Maximum	5981.666667
Zeros	2038
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	12
median	41.42833333
Q3	78.810375
95-th percentile	228.5795238
Maximum	5981.666667
Range	5981.666667
Interquartile range (IQR)	66.810375

Descriptive statistics

Standard deviation	160.6366626
Coefficient of variation (CV)	2.17306214
Kurtosis	265.0401262
Mean	73.92179897
Median Absolute Deviation (MAD)	34.08204617
Skewness	11.50961785
Sum	659382.4468
Variance	25804.13738
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2038	22.8%
50	30	0.3%
45.65	27	0.3%
60	22	0.2%
100	17	0.2%
25	16	0.2%
40	15	0.2%
20	11	0.1%
90	11	0.1%
45	10	0.1%
Other values (6161)	6723	75.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2038	22.8%
0.01	4	< 0.1%
0.05	1	< 0.1%
0.7	2	< 0.1%
0.7	3	< 0.1%
1	3	< 0.1%
1.48	1	< 0.1%
2	1	< 0.1%
2.783333333	1	< 0.1%
2.856	1	< 0.1%

Value	Count	Frequency (%)
5981.666667	1	< 0.1%
2900	1	< 0.1%
2600	1	< 0.1%
2523.438	1	< 0.1%
2483.26	1	< 0.1%
2190	1	< 0.1%
2000	2	< 0.1%
1875	1	< 0.1%
1865.044	1	< 0.1%
1810	1	< 0.1%

cash_advance_avg
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4309
Distinct (%)	48.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	209.2463055

Minimum	0
Maximum	14836.45141
Zeros	4612
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	69.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	247.4883825
95-th percentile	927.0156037
Maximum	14836.45141
Range	14836.45141
Interquartile range (IQR)	247.4883825

Descriptive statistics

Standard deviation	536.4028126
Coefficient of variation (CV)	2.563499563
Kurtosis	155.1960689
Mean	209.2463055
Median Absolute Deviation (MAD)	0
Skewness	9.618200794
Sum	1866477.045
Variance	287727.9774
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4612	51.7%
340.249539	1	< 0.1%
102.5884456	1	< 0.1%
1603.404898	1	< 0.1%
753.31351	1	< 0.1%
364.0986716	1	< 0.1%
1851.237848	1	< 0.1%
908.434086	1	< 0.1%
181.3516184	1	< 0.1%
338.3941967	1	< 0.1%
Other values (4299)	4299	48.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4612	51.7%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.1014785	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126347	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.1543055	1	< 0.1%

Value	Count	Frequency (%)
14836.45141	1	< 0.1%
10590.41113	1	< 0.1%
9798.167329	1	< 0.1%
9671.336737	1	< 0.1%
9553.955906	1	< 0.1%
7968.273359	1	< 0.1%
7894.578816	1	< 0.1%
7714.493122	1	< 0.1%
7413.65358	1	< 0.1%
7378.253685	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	cust_id	balance	balance_frequency	purchases	oneoff_purchases	installments_purchases	cash_advance	purchases_frequency	oneoff_purchases_frequency	purchases_installments_frequency	cash_advance_frequency	cash_advance_trx	purchases_trx	credit_limit	payments	minimum_payments	prc_full_payment	tenure	purchases_avg	cash_advance_avg
0	0	10001	40.900749	0.818182	95.40	0.00	95.40	0.000000	0.166667	0.000000	0.083333	0.000000	0	2	1000.0	201.802084	139.509787	0.000000	12	47.700000	0.000000
1	1	10002	3202.467416	0.909091	0.00	0.00	0.00	6442.945483	0.000000	0.000000	0.000000	0.250000	4	0	7000.0	4103.032597	1072.340217	0.222222	12	0.000000	1610.736371
2	2	10003	2495.148862	1.000000	773.17	773.17	0.00	0.000000	1.000000	1.000000	0.000000	0.000000	0	12	7500.0	622.066742	627.284787	0.000000	12	64.430833	0.000000
3	3	10004	1666.670542	0.636364	1499.00	1499.00	0.00	205.788017	0.083333	0.083333	0.000000	0.083333	1	1	7500.0	0.000000	0.000000	0.000000	12	1499.000000	205.788017
4	4	10005	817.714335	1.000000	16.00	16.00	0.00	0.000000	0.083333	0.083333	0.000000	0.000000	0	1	1200.0	678.334763	244.791237	0.000000	12	16.000000	0.000000
5	5	10006	1809.828751	1.000000	1333.28	0.00	1333.28	0.000000	0.666667	0.000000	0.583333	0.000000	0	8	1800.0	1400.057770	2407.246035	0.000000	12	166.660000	0.000000
6	6	10007	627.260806	1.000000	7091.01	6402.63	688.38	0.000000	1.000000	1.000000	1.000000	0.000000	0	64	13500.0	6354.314328	198.065894	1.000000	12	110.797031	0.000000
7	7	10008	1823.652743	1.000000	436.20	0.00	436.20	0.000000	1.000000	0.000000	1.000000	0.000000	0	12	2300.0	679.065082	532.033990	0.000000	12	36.350000	0.000000
8	8	10009	1014.926473	1.000000	861.49	661.49	200.00	0.000000	0.333333	0.083333	0.250000	0.000000	0	5	7000.0	688.278568	311.963409	0.000000	12	172.298000	0.000000
9	9	10010	152.225975	0.545455	1281.60	1281.60	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	3	11000.0	1164.770591	100.302262	0.000000	12	427.200000	0.000000

Last rows

	df_index	cust_id	balance	balance_frequency	purchases	oneoff_purchases	installments_purchases	cash_advance	purchases_frequency	oneoff_purchases_frequency	purchases_installments_frequency	cash_advance_frequency	cash_advance_trx	purchases_trx	credit_limit	payments	minimum_payments	prc_full_payment	tenure	purchases_avg	cash_advance_avg
8910	8940	19181	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	475.523262	82.771320	1.00	6	98.540000	0.000000
8911	8941	19182	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	9000.0	966.202912	861.949906	0.00	6	42.910000	658.108410
8912	8942	19183	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	94.488828	86.283101	0.25	6	18.880000	0.000000
8913	8943	19184	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	500.0	58.644883	43.473717	0.00	6	20.900000	0.000000
8914	8944	19185	193.571722	0.833333	1012.73	1012.73	0.00	0.000000	0.333333	0.333333	0.000000	0.000000	0	2	4000.0	0.000000	0.000000	0.00	6	506.365000	0.000000
8915	8945	19186	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	325.594462	48.886365	0.50	6	48.520000	0.000000
8916	8946	19187	19.183215	1.000000	300.00	0.00	300.00	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	275.861322	0.000000	0.00	6	50.000000	0.000000
8917	8947	19188	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	1000.0	81.270775	82.418369	0.25	6	28.880000	0.000000
8918	8948	19189	13.457564	0.833333	0.00	0.00	0.00	36.558778	0.000000	0.000000	0.000000	0.166667	2	0	500.0	52.549959	55.755628	0.25	6	0.000000	18.279389
8919	8949	19190	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	1200.0	63.165404	88.288956	0.00	6	47.532609	63.520004

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows